Excel 2016 in Applied Statistics for High School Students by Thomas J. Quirk

Author:Thomas J. Quirk
Language: eng
Format: epub
Publisher: Springer International Publishing, Cham

Now, write the following sentence in D31 to D34 to summarize the result of the study:

D31: Since the absolute value of −4.55

D32: is greater than the critical t of

D33: 1.96, we reject the null hypothesis

D34: and accept the research hypothesis.

Finally, write the following sentence in D36 to D38 to summarize the conclusion of the study in plain English:

D36: Teenage boys rated the taste of

D37: Pepsi as significantly better than

D38: the taste of Coke (64 vs. 55).

Save your file as: COKE4

Important note: You are probably wondering why we entered both the result and the conclusion in separate cells instead of in just one cell. This is because if you enter them in one cell, you will be very disappointed when you print out your final spreadsheet, because one of two things will happen that you will not like: (1) if you print the spreadsheet to fit onto only one page, the result and the conclusion will force the entire spreadsheet to be printed in such small font size that you will be unable to read it, or (2) if you do not print the final spreadsheet to fit onto one page, both the result and the conclusion will “dribble over” onto a second page instead of fitting the entire spreadsheet onto one page. In either case, your spreadsheet will not have a “professional look.”

Print this file so that it fits onto one page, and write by hand the null hypothesis and the research hypothesis on your printout.

The final spreadsheet appears in Fig. 5.12.

Fig. 5.12Final Worksheet for the Coke vs. Pepsi Taste Test

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.